insert into tmp_res(articleId,rank)
	select 	tblArticle.articleId,
			ifnull(tmp_1.rank,0)
	from tblArticle
		left join tblJournal on tblJournal.journalId=tblArticle.journalId
		left join tblJournalIssue on tblJournalIssue.journalIssueId=tblArticle.journalIssueId
    	left join tmp_1 on tmp_1.articleId = tblArticle.articleId
        
     	WHERE tblArticle.status='approved'
     	 AND (tmp_1.articleId IS NOT NULL) 
--     	ORDER BY rank desc, articleTitle